XMS/JSON Source Page

This mport wizard is designed to quickly transform structured XML/JSON data into a plain SQL table.

The process consists of two simple steps. First, select a source and choose a prototype node. A prototype node is a sample node used by the wizard to identify what data should be retrieved from the structured data (XML document). The wizard will find all the related nodes in the document, each one will represent a row in the destination table.

The second step is to define the projection columns, their names, type, default values and other options.

Defining The Source

Actions to complete the first step:

1. Select a data source. File and Web Service data sources are supported.
2. Next, the wizard will show the preview of the document in the tree. Select a prototype node by double-clicking on it or using the context (right-click) menu.
3. The tree on the right side shows the preview, the list of all the document nodes matching the prototype node.
4. Proceed to the next step using the
   Next
   button.

File Data Source

Here are some configuration options:

• Data source: a dropdown list of existing file data sources.
• File format: the content type of the source files: XML or JSON.
• File name: the name of the file in the data source.
• Encoding: file encoding, default is "UTF-8".
• Skip XML validation: is used to skip XML schema validation when the document is being parsed on the server. Recommended for big documents, as well as for performance reasons.

REST Web Service Data Source

Here are some configuration options:

• Data source: a dropdown list of existing web service data sources.
• End point: destination URL to perform requests.
• Action: HTTP action: GET or POST.
• Request content type: the media type for the request.
• Encoding: file encoding, default is "UTF-8".
• Request header: HTTP request header.
• Request: HTTP request body, for POST actions only.
• Response format: defines how to parse the response, as XML or as JSON data.
• Request rate limit: most Web Services have a request rate limit and its violation causes a requests to be declined. This configuration option defines a request rate limit per second for the wizard only, so that the previews are refreshed respecting this limit.

Data Processing Options

• Fetch items by selected path: configures the way the wizard finds nodes similar to the prototype node. If this option is selected, the wizard will scan only the subtree having the selected prototype node.
• Fetch all items: is the alternative option that forces wizard to scan the entire document for similar items.

Source data preview

Source data preview panel shows the original content of the file or web service response.
Note: the size of preview is limited to 64Kb.